IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'TEST')
BEGIN
    DROP TABLE [dbo].[TEST]
END

GO

CREATE TABLE [dbo].[TEST] ( 
	[ID]			 INT IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
    [TYPE] VARCHAR(10)    NOT NULL CONSTRAINT [CK_TEST_TYPE]
            CHECK (TYPE IN ('Read', 'Create', 'Edit', 'Delete'))
            DEFAULT 'Read'

    CONSTRAINT [PK_TEST_ID] PRIMARY KEY CLUSTERED ( 
        [ID] 
    ) ON [PRIMARY],
    
    
) ON [PRIMARY]
GO